﻿CREATE TABLE [dbo].[NetworkInterface] (
    [ComputerId]          INT            NOT NULL,
    [Id]                  NVARCHAR (100) NOT NULL,
    [Name]                NVARCHAR (100) NOT NULL,
    [PhysicalAddress]     NVARCHAR (50)  NOT NULL,
    [Description]         NVARCHAR (300) NULL,
    [DHCPServer]          NVARCHAR (50)  NULL,
    [IPAddress]           NVARCHAR (50)  NULL,
    [DefaultGateway]      NVARCHAR (50)  NULL,
    [TypeId]              SMALLINT       NOT NULL,
    [OperationalStatusId] TINYINT        NOT NULL,
    [LeaseObtained]       DATETIME       NULL,
    [LeaseExpires]        DATETIME       NULL
);

